Ecommerce Sales Data Analysis Report

Dataset statistics

Number of variables	15
Number of observations	100000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	11.4 MiB
Average record size in memory	120.0 B

Variable types

Numeric	12
DateTime	1
Categorical	2

Alerts

`AOV` is highly overall correlated with `ROAS` and 1 other fields	High correlation
`Ad_CPC` is highly overall correlated with `Ad_Spend`	High correlation
`Ad_CTR` is highly overall correlated with `Ad_Spend`	High correlation
`Ad_Spend` is highly overall correlated with `Ad_CPC` and 2 other fields	High correlation
`Clicks` is highly overall correlated with `Conversion_Rate`	High correlation
`Conversion_Rate` is highly overall correlated with `Clicks` and 1 other fields	High correlation
`Impressions` is highly overall correlated with `Conversion_Rate`	High correlation
`ROAS` is highly overall correlated with `AOV` and 2 other fields	High correlation
`Revenue` is highly overall correlated with `AOV` and 1 other fields	High correlation
`Discount_Applied` has 1685 (1.7%) zeros	Zeros
`Clicks` has 1999 (2.0%) zeros	Zeros
`Conversion_Rate` has 3621 (3.6%) zeros	Zeros

Reproduction

Analysis started	2024-12-08 22:29:29.751739
Analysis finished	2024-12-08 22:30:01.453078
Duration	31.7 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

Product_ID
Real number (ℝ)

Distinct	1000
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	499.51473

Minimum	0
Maximum	999
Zeros	110
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	250
median	500
Q3	749
95-th percentile	950
Maximum	999
Range	999
Interquartile range (IQR)	499

Descriptive statistics

Standard deviation	288.77872
Coefficient of variation (CV)	0.57811853
Kurtosis	-1.2002857
Mean	499.51473
Median Absolute Deviation (MAD)	250
Skewness	-3.3552055 × 10^-5
Sum	49951473
Variance	83393.151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
521	137	0.1%
130	135	0.1%
933	133	0.1%
829	132	0.1%
719	132	0.1%
835	129	0.1%
111	127	0.1%
276	127	0.1%
1	126	0.1%
606	126	0.1%
Other values (990)	98696	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	110	0.1%
1	126	0.1%
2	106	0.1%
3	89	0.1%
4	102	0.1%
5	101	0.1%
6	85	0.1%
7	92	0.1%
8	109	0.1%
9	86	0.1%

Value	Count	Frequency (%)
999	101	0.1%
998	116	0.1%
997	101	0.1%
996	89	0.1%
995	105	0.1%
994	107	0.1%
993	95	0.1%
992	89	0.1%
991	87	0.1%
990	114	0.1%

Transaction_Date
Date

Distinct	366
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Minimum	2023-12-07 00:00:00
Maximum	2024-12-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Units_Sold
Real number (ℝ)

Distinct	344
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	128.32858

Minimum	51
Maximum	716
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	51
5-th percentile	61
Q1	84
median	127
Q3	166
95-th percentile	208
Maximum	716
Range	665
Interquartile range (IQR)	82

Descriptive statistics

Standard deviation	49.679873
Coefficient of variation (CV)	0.38713023
Kurtosis	4.4677607
Mean	128.32858
Median Absolute Deviation (MAD)	41
Skewness	0.86305924
Sum	12832858
Variance	2468.0897
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
72	1133	1.1%
68	1102	1.1%
79	1066	1.1%
70	1062	1.1%
165	1046	1.0%
62	1026	1.0%
80	1020	1.0%
77	1019	1.0%
64	1009	1.0%
75	989	1.0%
Other values (334)	89528	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51	106	0.1%
52	158	0.2%
53	284	0.3%
54	327	0.3%
55	307	0.3%
56	517	0.5%
57	495	0.5%
58	744	0.7%
59	688	0.7%
60	700	0.7%

Value	Count	Frequency (%)
716	1	< 0.1%
706	1	< 0.1%
702	1	< 0.1%
692	1	< 0.1%
677	1	< 0.1%
663	1	< 0.1%
659	1	< 0.1%
656	1	< 0.1%
639	4	< 0.1%
636	1	< 0.1%

Discount_Applied
Real number (ℝ)

ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1498715

Minimum	0
Maximum	0.3
Zeros	1685
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.01
Q1	0.07
median	0.15
Q3	0.22
95-th percentile	0.29
Maximum	0.3
Range	0.3
Interquartile range (IQR)	0.15

Descriptive statistics

Standard deviation	0.086691785
Coefficient of variation (CV)	0.57844077
Kurtosis	-1.1911827
Mean	0.1498715
Median Absolute Deviation (MAD)	0.07
Skewness	-0.00016104881
Sum	14987.15
Variance	0.0075154656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0.04	3440	3.4%
0.15	3434	3.4%
0.23	3411	3.4%
0.17	3403	3.4%
0.03	3395	3.4%
0.1	3388	3.4%
0.29	3381	3.4%
0.18	3376	3.4%
0.19	3374	3.4%
0.27	3371	3.4%
Other values (21)	66027	66.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1685	1.7%
0.01	3358	3.4%
0.02	3305	3.3%
0.03	3395	3.4%
0.04	3440	3.4%
0.05	3259	3.3%
0.06	3348	3.3%
0.07	3234	3.2%
0.08	3292	3.3%
0.09	3289	3.3%

Value	Count	Frequency (%)
0.3	1683	1.7%
0.29	3381	3.4%
0.28	3226	3.2%
0.27	3371	3.4%
0.26	3286	3.3%
0.25	3211	3.2%
0.24	3368	3.4%
0.23	3411	3.4%
0.22	3337	3.3%
0.21	3302	3.3%

Revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	51950
Distinct (%)	51.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	553.11081

Minimum	7.65
Maximum	5704.18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	7.65
5-th percentile	58.18
Q1	221.26
median	428.155
Q3	805.865
95-th percentile	1394.8115
Maximum	5704.18
Range	5696.53
Interquartile range (IQR)	584.605

Descriptive statistics

Standard deviation	428.36629
Coefficient of variation (CV)	0.77446741
Kurtosis	2.5510045
Mean	553.11081
Median Absolute Deviation (MAD)	264.82
Skewness	1.1713089
Sum	55311081
Variance	183497.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1078.59	13	< 0.1%
96.16	12	< 0.1%
89.91	11	< 0.1%
173.61	11	< 0.1%
65.5	11	< 0.1%
492.92	10	< 0.1%
346.74	10	< 0.1%
331.66	10	< 0.1%
155.66	10	< 0.1%
298.08	10	< 0.1%
Other values (51940)	99892	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.65	1	< 0.1%
8.19	2	< 0.1%
8.3	3	< 0.1%
8.39	1	< 0.1%
8.4	1	< 0.1%
8.41	2	< 0.1%
8.52	5	< 0.1%
8.53	1	< 0.1%
8.63	1	< 0.1%
8.64	2	< 0.1%

Value	Count	Frequency (%)
5704.18	1	< 0.1%
5433.46	1	< 0.1%
5397.12	1	< 0.1%
4980.53	1	< 0.1%
4875.95	1	< 0.1%
4864.31	1	< 0.1%
4629.08	1	< 0.1%
4574.36	1	< 0.1%
4571.41	1	< 0.1%
4559.46	1	< 0.1%

Clicks
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.53917

Minimum	0
Maximum	49
Zeros	1999
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	12
median	25
Q3	37
95-th percentile	47
Maximum	49
Range	49
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.412477
Coefficient of variation (CV)	0.58732535
Kurtosis	-1.2001615
Mean	24.53917
Median Absolute Deviation (MAD)	12
Skewness	-0.0049981154
Sum	2453917
Variance	207.71948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	2091	2.1%
42	2083	2.1%
39	2066	2.1%
36	2063	2.1%
17	2060	2.1%
11	2059	2.1%
27	2057	2.1%
21	2052	2.1%
33	2049	2.0%
46	2030	2.0%
Other values (40)	79390	79.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1999	2.0%
1	1990	2.0%
2	1959	2.0%
3	1923	1.9%
4	1984	2.0%
5	1992	2.0%
6	2028	2.0%
7	2015	2.0%
8	2012	2.0%
9	2006	2.0%

Value	Count	Frequency (%)
49	1980	2.0%
48	1958	2.0%
47	2016	2.0%
46	2030	2.0%
45	2026	2.0%
44	2001	2.0%
43	1939	1.9%
42	2083	2.1%
41	1900	1.9%
40	1944	1.9%

Impressions
Real number (ℝ)

HIGH CORRELATION

Distinct	490
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	254.53906

Minimum	10
Maximum	499
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	10
5-th percentile	34
Q1	132
median	254
Q3	377
95-th percentile	475
Maximum	499
Range	489
Interquartile range (IQR)	245

Descriptive statistics

Standard deviation	141.46661
Coefficient of variation (CV)	0.55577563
Kurtosis	-1.2011747
Mean	254.53906
Median Absolute Deviation (MAD)	122
Skewness	8.50296 × 10^-5
Sum	25453906
Variance	20012.801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	240	0.2%
410	239	0.2%
376	238	0.2%
412	237	0.2%
212	237	0.2%
447	237	0.2%
196	236	0.2%
44	236	0.2%
133	235	0.2%
156	235	0.2%
Other values (480)	97630	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	208	0.2%
11	175	0.2%
12	198	0.2%
13	201	0.2%
14	207	0.2%
15	207	0.2%
16	187	0.2%
17	184	0.2%
18	191	0.2%
19	209	0.2%

Value	Count	Frequency (%)
499	209	0.2%
498	201	0.2%
497	224	0.2%
496	221	0.2%
495	183	0.2%
494	208	0.2%
493	214	0.2%
492	188	0.2%
491	201	0.2%
490	198	0.2%

Conversion_Rate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	333
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1981378

Minimum	0
Maximum	4.9
Zeros	3621
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.01
Q1	0.05
median	0.1
Q3	0.19
95-th percentile	0.74
Maximum	4.9
Range	4.9
Interquartile range (IQR)	0.14

Descriptive statistics

Standard deviation	0.36118743
Coefficient of variation (CV)	1.8229103
Kurtosis	37.730717
Mean	0.1981378
Median Absolute Deviation (MAD)	0.06
Skewness	5.3076844
Sum	19813.78
Variance	0.13045636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.09	5196	5.2%
0.08	5145	5.1%
0.07	5135	5.1%
0.05	5121	5.1%
0.06	5095	5.1%
0.04	5081	5.1%
0.02	5062	5.1%
0.03	5035	5.0%
0.1	4959	5.0%
0.01	4901	4.9%
Other values (323)	49270	49.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3621	3.6%
0.01	4901	4.9%
0.02	5062	5.1%
0.03	5035	5.0%
0.04	5081	5.1%
0.05	5121	5.1%
0.06	5095	5.1%
0.07	5135	5.1%
0.08	5145	5.1%
0.09	5196	5.2%

Value	Count	Frequency (%)
4.9	1	< 0.1%
4.8	5	< 0.1%
4.7	4	< 0.1%
4.6	4	< 0.1%
4.5	5	< 0.1%
4.45	3	< 0.1%
4.4	1	< 0.1%
4.36	3	< 0.1%
4.3	1	< 0.1%
4.27	5	< 0.1%

Category
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

2	21533
4	20764
3	19419
1	19278
0	19006

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	100000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	3
3rd row	4
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
2	21533	21.5%
4	20764	20.8%
3	19419	19.4%
1	19278	19.3%
0	19006	19.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	21533	21.5%
4	20764	20.8%
3	19419	19.4%
1	19278	19.3%
0	19006	19.0%

Most occurring characters

Value	Count	Frequency (%)
2	21533	21.5%
4	20764	20.8%
3	19419	19.4%
1	19278	19.3%
0	19006	19.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	21533	21.5%
4	20764	20.8%
3	19419	19.4%
1	19278	19.3%
0	19006	19.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	21533	21.5%
4	20764	20.8%
3	19419	19.4%
1	19278	19.3%
0	19006	19.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	21533	21.5%
4	20764	20.8%
3	19419	19.4%
1	19278	19.3%
0	19006	19.0%

Region
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

0	33472
1	33265
2	33263

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	100000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
0	33472	33.5%
1	33265	33.3%
2	33263	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	33472	33.5%
1	33265	33.3%
2	33263	33.3%

Most occurring characters

Value	Count	Frequency (%)
0	33472	33.5%
1	33265	33.3%
2	33263	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	33472	33.5%
1	33265	33.3%
2	33263	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	33472	33.5%
1	33265	33.3%
2	33263	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	33472	33.5%
1	33265	33.3%
2	33263	33.3%

Ad_CTR
Real number (ℝ)

HIGH CORRELATION

Distinct	1901
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10498773

Minimum	0.01
Maximum	0.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.0196
Q1	0.0575
median	0.1052
Q3	0.1523
95-th percentile	0.1907
Maximum	0.2
Range	0.19
Interquartile range (IQR)	0.0948

Descriptive statistics

Standard deviation	0.054806269
Coefficient of variation (CV)	0.52202548
Kurtosis	-1.1941851
Mean	0.10498773
Median Absolute Deviation (MAD)	0.0474
Skewness	0.0028388654
Sum	10498.773
Variance	0.0030037271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.08	81	0.1%
0.1264	74	0.1%
0.1267	74	0.1%
0.1646	73	0.1%
0.0793	73	0.1%
0.0155	73	0.1%
0.1219	73	0.1%
0.0603	73	0.1%
0.13	73	0.1%
0.0339	73	0.1%
Other values (1891)	99260	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	25	< 0.1%
0.0101	40	< 0.1%
0.0102	54	0.1%
0.0103	57	0.1%
0.0104	57	0.1%
0.0105	57	0.1%
0.0106	59	0.1%
0.0107	48	< 0.1%
0.0108	57	0.1%
0.0109	58	0.1%

Value	Count	Frequency (%)
0.2	29	< 0.1%
0.1999	50	0.1%
0.1998	57	0.1%
0.1997	53	0.1%
0.1996	60	0.1%
0.1995	55	0.1%
0.1994	43	< 0.1%
0.1993	55	0.1%
0.1992	56	0.1%
0.1991	66	0.1%

Ad_CPC
Real number (ℝ)

HIGH CORRELATION

Distinct	191
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0512502

Minimum	0.1
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0.1
5-th percentile	0.19
Q1	0.58
median	1.05
Q3	1.53
95-th percentile	1.91
Maximum	2
Range	1.9
Interquartile range (IQR)	0.95

Descriptive statistics

Standard deviation	0.54925209
Coefficient of variation (CV)	0.52247514
Kurtosis	-1.203856
Mean	1.0512502
Median Absolute Deviation (MAD)	0.48
Skewness	-0.0025045966
Sum	105125.02
Variance	0.30167786
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.66	580	0.6%
0.67	577	0.6%
1.97	575	0.6%
1.66	575	0.6%
0.76	571	0.6%
1.37	570	0.6%
1.96	568	0.6%
0.3	566	0.6%
1.69	566	0.6%
0.16	564	0.6%
Other values (181)	94288	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	268	0.3%
0.11	503	0.5%
0.12	507	0.5%
0.13	521	0.5%
0.14	553	0.6%
0.15	513	0.5%
0.16	564	0.6%
0.17	548	0.5%
0.18	516	0.5%
0.19	529	0.5%

Value	Count	Frequency (%)
2	276	0.3%
1.99	522	0.5%
1.98	540	0.5%
1.97	575	0.6%
1.96	568	0.6%
1.95	495	0.5%
1.94	507	0.5%
1.93	494	0.5%
1.92	518	0.5%
1.91	546	0.5%

Ad_Spend
Real number (ℝ)

HIGH CORRELATION

Distinct	27756
Distinct (%)	27.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	110.47724

Minimum	1.05
Maximum	399.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	1.05
5-th percentile	11.68
Q1	38.61
median	87.24
Q3	164.22
95-th percentile	286.9505
Maximum	399.6
Range	398.55
Interquartile range (IQR)	125.61

Descriptive statistics

Standard deviation	87.015846
Coefficient of variation (CV)	0.78763595
Kurtosis	0.040110794
Mean	110.47724
Median Absolute Deviation (MAD)	56.57
Skewness	0.91088071
Sum	11047724
Variance	7571.7574
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.9	23	< 0.1%
26.4	22	< 0.1%
31.62	22	< 0.1%
57.72	22	< 0.1%
22.18	22	< 0.1%
14.76	22	< 0.1%
34.1	21	< 0.1%
31.46	21	< 0.1%
19.55	21	< 0.1%
27.72	21	< 0.1%
Other values (27746)	99783	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.05	1	< 0.1%
1.11	1	< 0.1%
1.12	1	< 0.1%
1.13	1	< 0.1%
1.16	1	< 0.1%
1.21	1	< 0.1%
1.22	1	< 0.1%
1.23	1	< 0.1%
1.24	1	< 0.1%
1.25	1	< 0.1%

Value	Count	Frequency (%)
399.6	1	< 0.1%
397.8	1	< 0.1%
397.4	2	< 0.1%
396.41	1	< 0.1%
395.6	3	< 0.1%
395.21	2	< 0.1%
395.2	1	< 0.1%
394.42	1	< 0.1%
394	1	< 0.1%
393.82	1	< 0.1%

AOV
Real number (ℝ)

HIGH CORRELATION

Distinct	98494
Distinct (%)	98.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.0124039

Minimum	0.04076555
Maximum	35.787407
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0.04076555
5-th percentile	0.45048427
Q1	1.7163424
median	3.6395381
Q3	6.8815433
95-th percentile	14.503062
Maximum	35.787407
Range	35.746642
Interquartile range (IQR)	5.1652008

Descriptive statistics

Standard deviation	4.5725213
Coefficient of variation (CV)	0.91224119
Kurtosis	3.4663514
Mean	5.0124039
Median Absolute Deviation (MAD)	2.2828193
Skewness	1.6956415
Sum	501240.39
Variance	20.907951
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.2	4	< 0.1%
4.345	4	< 0.1%
5.55	4	< 0.1%
4.97	4	< 0.1%
4.18	4	< 0.1%
2.03	4	< 0.1%
2.44	4	< 0.1%
0.76	4	< 0.1%
0.47	4	< 0.1%
0.7614285714	4	< 0.1%
Other values (98484)	99960	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.04076555024	1	< 0.1%
0.04401960784	1	< 0.1%
0.04460784314	1	< 0.1%
0.04507936508	1	< 0.1%
0.04656565657	1	< 0.1%
0.04722222222	1	< 0.1%
0.04848039216	1	< 0.1%
0.04904255319	1	< 0.1%
0.04961206897	1	< 0.1%
0.05024509804	1	< 0.1%

Value	Count	Frequency (%)
35.78740741	1	< 0.1%
35.28363636	1	< 0.1%
35.12611111	1	< 0.1%
34.79581818	1	< 0.1%
34.36407407	1	< 0.1%
33.7559322	1	< 0.1%
33.59107143	1	< 0.1%
33.45254237	1	< 0.1%
33.00084746	1	< 0.1%
32.71035714	1	< 0.1%

ROAS
Real number (ℝ)

HIGH CORRELATION

Distinct	99977
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.66115

Minimum	0.024971847
Maximum	1145.0743
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0.024971847
5-th percentile	0.50670056
Q1	2.0753293
median	5.0818523
Q3	12.756096
95-th percentile	52.11139
Maximum	1145.0743
Range	1145.0494
Interquartile range (IQR)	10.680767

Descriptive statistics

Standard deviation	31.564643
Coefficient of variation (CV)	2.3105407
Kurtosis	172.80231
Mean	13.66115
Median Absolute Deviation (MAD)	3.743635
Skewness	9.8289965
Sum	1366115
Variance	996.32668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.27862503	2	< 0.1%
5.215155152	2	< 0.1%
13.27424749	2	< 0.1%
3.079710145	2	< 0.1%
18.39308579	2	< 0.1%
12.84504792	2	< 0.1%
29	2	< 0.1%
15.61111111	2	< 0.1%
2.928571429	2	< 0.1%
5.666666667	2	< 0.1%
Other values (99967)	99980	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02497184685	1	< 0.1%
0.02847441313	1	< 0.1%
0.03099730458	1	< 0.1%
0.03184142853	1	< 0.1%
0.0321845175	1	< 0.1%
0.03228743522	1	< 0.1%
0.03248444049	1	< 0.1%
0.03254488216	1	< 0.1%
0.03258224072	1	< 0.1%
0.03304440592	1	< 0.1%

Value	Count	Frequency (%)
1145.074324	1	< 0.1%
1115.720588	1	< 0.1%
1061.974138	1	< 0.1%
1037.351351	1	< 0.1%
949.5136986	1	< 0.1%
894.056338	1	< 0.1%
830.9381443	1	< 0.1%
763.4064039	1	< 0.1%
756.0785714	1	< 0.1%
742.9907063	1	< 0.1%

Auto

Heatmap
Table

	AOV	Ad_CPC	Ad_CTR	Ad_Spend	Category	Clicks	Conversion_Rate	Discount_Applied	Impressions	Product_ID	ROAS	Region	Revenue	Units_Sold
AOV	1.000	0.003	0.006	0.007	0.053	0.005	0.001	-0.097	0.005	-0.001	0.611	0.078	0.908	-0.381
Ad_CPC	0.003	1.000	0.004	0.679	0.004	-0.005	-0.007	0.003	0.006	-0.003	-0.478	0.000	0.002	-0.003
Ad_CTR	0.006	0.004	1.000	0.679	0.003	0.004	0.005	-0.003	-0.005	0.004	-0.474	0.000	0.007	0.000
Ad_Spend	0.007	0.679	0.679	1.000	0.003	-0.001	-0.001	-0.001	0.001	0.001	-0.700	0.006	0.006	-0.003
Category	0.053	0.004	0.003	0.003	1.000	0.000	0.000	0.000	0.000	0.093	0.004	0.000	0.025	0.079
Clicks	0.005	-0.005	0.004	-0.001	0.000	1.000	0.697	-0.003	0.002	-0.001	0.006	0.000	0.007	0.004
Conversion_Rate	0.001	-0.007	0.005	-0.001	0.000	0.697	1.000	-0.002	-0.635	-0.004	0.003	0.000	0.002	0.001
Discount_Applied	-0.097	0.003	-0.003	-0.001	0.000	-0.003	-0.002	1.000	-0.004	-0.002	-0.073	0.000	-0.110	-0.000
Impressions	0.005	0.006	-0.005	0.001	0.000	0.002	-0.635	-0.004	1.000	0.003	0.003	0.009	0.005	0.001
Product_ID	-0.001	-0.003	0.004	0.001	0.093	-0.001	-0.004	-0.002	0.003	1.000	-0.004	0.000	-0.001	-0.002
ROAS	0.611	-0.478	-0.474	-0.700	0.004	0.006	0.003	-0.073	0.003	-0.004	1.000	0.007	0.669	0.010
Region	0.078	0.000	0.000	0.006	0.000	0.000	0.000	0.000	0.009	0.000	0.007	1.000	0.006	0.277
Revenue	0.908	0.002	0.007	0.006	0.025	0.007	0.002	-0.110	0.005	-0.001	0.669	0.006	1.000	0.010
Units_Sold	-0.381	-0.003	0.000	-0.003	0.079	0.004	0.001	-0.000	0.001	-0.002	0.010	0.277	0.010	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Product_ID	Transaction_Date	Units_Sold	Discount_Applied	Revenue	Clicks	Impressions	Conversion_Rate	Category	Region	Ad_CTR	Ad_CPC	Ad_Spend	AOV	ROAS
0	140	2024-10-06	134	0.14	305.54	11	65	0.17	2	1	0.0180	0.55	9.90	2.280149	30.862626
1	539	2024-10-29	109	0.30	1102.19	15	201	0.07	3	0	0.1589	0.40	63.56	10.111835	17.340938
2	306	2024-04-04	116	0.04	471.29	16	199	0.08	4	0	0.0596	1.50	89.40	4.062845	5.271700
3	136	2024-08-25	125	0.20	980.26	12	355	0.03	1	1	0.0444	0.44	19.54	7.842080	50.166837
4	288	2024-05-05	132	0.07	803.76	44	355	0.12	0	2	0.1270	0.53	67.31	6.089091	11.941168
5	38	2024-09-22	160	0.25	69.37	4	73	0.05	2	2	0.0153	1.13	17.29	0.433563	4.012146
6	567	2023-12-08	145	0.17	121.56	25	110	0.23	1	2	0.0889	1.97	175.13	0.838345	0.694113
7	546	2024-04-30	121	0.28	208.64	1	208	0.00	2	0	0.0133	1.22	16.23	1.724298	12.855206
8	787	2024-04-10	152	0.20	757.34	27	73	0.37	4	2	0.1562	1.55	242.11	4.982500	3.128082
9	64	2024-11-24	152	0.17	163.74	10	299	0.03	4	2	0.0728	0.75	54.60	1.077237	2.998901

	Product_ID	Transaction_Date	Units_Sold	Discount_Applied	Revenue	Clicks	Impressions	Conversion_Rate	Category	Region	Ad_CTR	Ad_CPC	Ad_Spend	AOV	ROAS
99990	163	2024-07-19	163	0.25	664.66	46	407	0.11	2	0	0.0296	1.84	54.46	4.077669	12.204554
99991	800	2024-11-05	182	0.10	777.02	31	196	0.16	2	1	0.1607	0.67	107.67	4.269341	7.216681
99992	984	2024-06-23	148	0.08	373.52	8	456	0.02	0	1	0.0685	1.70	116.45	2.523784	3.207557
99993	582	2024-01-21	163	0.06	213.25	3	340	0.01	1	1	0.0135	0.45	6.07	1.308282	35.131796
99994	247	2024-01-07	175	0.02	142.16	9	461	0.02	0	2	0.0363	1.11	40.29	0.812343	3.528419
99995	415	2024-04-21	179	0.11	255.11	41	428	0.10	2	1	0.1073	1.48	158.80	1.425196	1.606486
99996	764	2024-09-17	178	0.12	1302.60	6	363	0.02	0	2	0.1164	0.36	41.90	7.317978	31.088305
99997	718	2024-10-23	212	0.26	491.36	5	419	0.01	2	2	0.1235	0.20	24.70	2.317736	19.893117
99998	323	2024-01-03	180	0.09	598.91	41	12	3.42	2	1	0.1566	0.96	150.34	3.327278	3.983704
99999	139	2024-07-12	157	0.20	208.27	34	334	0.10	4	0	0.0926	0.61	56.49	1.326561	3.686847

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample